//=============================================================================
//===	Copyright (C) 2001-2007 Food and Agriculture Organization of the
//===	United Nations (FAO-UN), United Nations World Food Programme (WFP)
//===	and United Nations Environment Programme (UNEP)
//===
//===	This program is free software; you can redistribute it and/or modify
//===	it under the terms of the GNU General Public License as published by
//===	the Free Software Foundation; either version 2 of the License, or (at
//===	your option) any later version.
//===
//===	This program is distributed in the hope that it will be useful, but
//===	WITHOUT ANY WARRANTY; without even the implied warranty of
//===	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
//===	General Public License for more details.
//===
//===	You should have received a copy of the GNU General Public License
//===	along with this program; if not, write to the Free Software
//===	Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
//===
//===	Contact: Jeroen Ticheler - FAO - Viale delle Terme di Caracalla 2,
//===	Rome - Italy. email: geonetwork@osgeo.org
//==============================================================================

package org.fao.geonet.services.metadata;

import java.util.HashSet;
import java.util.List;
import jeeves.constants.Jeeves;
import jeeves.interfaces.Service;
import jeeves.resources.dbms.Dbms;
import jeeves.server.ServiceConfig;
import jeeves.server.context.ServiceContext;
import jeeves.utils.Util;
import org.fao.geonet.GeonetContext;
import org.fao.geonet.constants.Geonet;
import org.fao.geonet.constants.Params;
import org.fao.geonet.kernel.DataManager;
import org.fao.geonet.lib.Lib;
import org.jdom.Element;

//=============================================================================

/**
 * Given a metadata id returns all associated categories. Called by the
 * metadata.category service
 */

public class GetCategories implements Service {
	// --------------------------------------------------------------------------
	// ---
	// --- Init
	// ---
	// --------------------------------------------------------------------------

	public void init(String appPath, ServiceConfig params) throws Exception {
	}

	// --------------------------------------------------------------------------
	// ---
	// --- Service
	// ---
	// --------------------------------------------------------------------------

	public Element exec(Element params, ServiceContext context)
			throws Exception {
		GeonetContext gc = (GeonetContext) context
				.getHandlerContext(Geonet.CONTEXT_NAME);
		DataManager dataMan = gc.getDataManager();

		Dbms dbms = (Dbms) context.getResourceManager()
				.open(Geonet.Res.MAIN_DB);

		String id = Util.getParam(params, Params.ID);

		// -----------------------------------------------------------------------
		// --- check access

		if (!dataMan.existsMetadata(dbms, id))
			throw new IllegalArgumentException("Metadata not found --> " + id);

		// -----------------------------------------------------------------------
		// --- retrieve metadata categories

		HashSet hsMetadataCat = new HashSet();

		List mdCat = dbms.select(
				"SELECT categoryId FROM MetadataCateg WHERE metadataId=" + id)
				.getChildren();

		for (int i = 0; i < mdCat.size(); i++) {
			Element el = (Element) mdCat.get(i);
			hsMetadataCat.add(el.getChildText("categoryid"));
		}

		// -----------------------------------------------------------------------
		// --- retrieve groups operations
		Element elCateg = Lib.local.retrieve(dbms, "Categories");

		List list = elCateg.getChildren();
		for (int i = 0; i < list.size(); i++) {
			Element el = (Element) list.get(i);
			el.setName(Geonet.Elem.CATEGORY);
			// --- get all operations that this group can do on given metadata
			if (hsMetadataCat.contains(el.getChildText("id"))) {
				el.addContent(new Element("on"));
				// Buscar el grupo y la categoria, del subgrupo seleccionado
				if (el.getChildText("id_category_parent") != null
						&& !el.getChildText("id_category_parent").equals("")) {
					System.out
							.println("EXEC SELECT id_category_parent FROM Categories WHERE id="
									+ el.getChildText("id_category_parent"));
					List category = dbms.select(
							"SELECT id_category_parent FROM Categories WHERE id="
									+ el.getChildText("id_category_parent"))
							.getChildren();
					el.addContent(new Element("groupId").setText(el
							.getChildText("id_category_parent")));
					
					if (!category.isEmpty()) {
						Element catEl = (Element) category.get(0);
						el.addContent(new Element("categoryId").setText(catEl
								.getChildText("id_category_parent")));
					}
				}
			}
		}

		// -----------------------------------------------------------------------
		// --- put all together
		Element elRes = new Element(Jeeves.Elem.RESPONSE);
		elRes.addContent(new Element(Geonet.Elem.ID).setText(id)).addContent(
				elCateg);
		return elRes;
	}
}

// =============================================================================

